package cn.com.bdqn.dao;

import cn.com.bdqn.entity.SyEmpAreaPower;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface SyEmpAreaPowerDao {

    @Select("select * from sy_empareapower where EmpID = #{value}")
    public List<SyEmpAreaPower> queryByEmpId(Long empId);

    @Delete("delete from sy_empareapower where EmpID = #{value}")
    public int delSyEmpAreaPower(Long empId);

    @Insert("insert into sy_empareapower values\n" +
            "(default,#{empId},#{areaId})")
    public int addSyEmpAreaPower(SyEmpAreaPower syEmpAreaPower);
}
